﻿CREATE TABLE [org].[Project] (
    [ProjectId]               INT             NOT NULL,
    [ProjectCode]             CHAR (5)        NOT NULL,
    [ProjectName]             VARCHAR (50)    NOT NULL,
    [ProjectDescription]      NVARCHAR (1000) NULL,
    [ProjectStartDate]        DATE            NOT NULL,
    [ProjectEndDate]          DATE            NULL,
    [ProjectClassificationId] SMALLINT        NOT NULL,
    [ProjectTreatmentId]      SMALLINT        NOT NULL,
    [ProjectSystemId]         SMALLINT        NOT NULL,
    [IsLatest]                BIT             NOT NULL,
    [IsActive]                BIT             NOT NULL,
    [IsInternal]              BIT             NOT NULL,
    PRIMARY KEY CLUSTERED ([ProjectId] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF)
);

